Dataset statistics
| Number of variables | 27 |
|---|---|
| Number of observations | 165 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 34.9 KiB |
| Average record size in memory | 216.8 B |
Variable types
| NUM | 25 |
|---|---|
| BOOL | 2 |
Reproduction
| Analysis started | 2020-07-01 15:55:34.039670 |
|---|---|
| Analysis finished | 2020-07-01 15:57:15.917615 |
| Duration | 1 minute and 41.88 seconds |
| Version | pandas-profiling v2.8.0 |
| Command line | pandas_profiling --config_file config.yaml [YOUR_FILE.csv] |
| Download configuration | config.yaml |
songs_played is highly correlated with page_count and 5 other fields | High correlation |
page_count is highly correlated with songs_played and 5 other fields | High correlation |
songs_playlisted is highly correlated with page_count and 5 other fields | High correlation |
thumbed_up is highly correlated with page_count and 4 other fields | High correlation |
added_friends is highly correlated with page_count and 4 other fields | High correlation |
error_count is highly correlated with page_count and 5 other fields | High correlation |
redirect_count is highly correlated with page_count and 5 other fields | High correlation |
7d_songs_playlisted is highly correlated with 7d_songs_played | High correlation |
7d_songs_played is highly correlated with 7d_songs_playlisted and 1 other fields | High correlation |
7d_thumbed_up is highly correlated with 7d_songs_played | High correlation |
interactions_per_day is highly correlated with songs_per_day | High correlation |
songs_per_day is highly correlated with interactions_per_day | High correlation |
inter_per_session is highly correlated with time_mean | High correlation |
time_mean is highly correlated with inter_per_session | High correlation |
df_index has unique values | Unique |
thumbed_up_ratio has unique values | Unique |
songs_per_day has unique values | Unique |
interactions_per_day has unique values | Unique |
thumbed_down has 4 (2.4%) zeros | Zeros |
7d_songs_playlisted has 11 (6.7%) zeros | Zeros |
7d_thumbed_up has 3 (1.8%) zeros | Zeros |
7d_thumbed_down has 32 (19.4%) zeros | Zeros |
7d_added_friends has 27 (16.4%) zeros | Zeros |
thumbed_down_ratio has 4 (2.4%) zeros | Zeros |
| Distinct count | 165 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 117.14545454545454 |
|---|---|
| Minimum | 0 |
| Maximum | 224 |
| Zeros | 1 |
| Zeros (%) | 0.6% |
| Memory size | 1.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 14.2 |
| Q1 | 64 |
| median | 123 |
| Q3 | 169 |
| 95-th percentile | 213.8 |
| Maximum | 224 |
| Range | 224 |
| Interquartile range (IQR) | 105 |
Descriptive statistics
| Standard deviation | 63.53751096 |
|---|---|
| Coefficient of variation (CV) | 0.5423813601 |
| Kurtosis | -1.110552042 |
| Mean | 117.1454545 |
| Median Absolute Deviation (MAD) | 53 |
| Skewness | -0.1125336177 |
| Sum | 19329 |
| Variance | 4037.015299 |
| Value | Count | Frequency (%) | |
| 224 | 1 | 0.6% | |
| 91 | 1 | 0.6% | |
| 89 | 1 | 0.6% | |
| 88 | 1 | 0.6% | |
| 87 | 1 | 0.6% | |
| 86 | 1 | 0.6% | |
| 84 | 1 | 0.6% | |
| 82 | 1 | 0.6% | |
| 81 | 1 | 0.6% | |
| 80 | 1 | 0.6% | |
| Other values (155) | 155 | 93.9% |
| Value | Count | Frequency (%) | |
| 0 | 1 | 0.6% | |
| 1 | 1 | 0.6% | |
| 3 | 1 | 0.6% | |
| 5 | 1 | 0.6% | |
| 8 | 1 | 0.6% |
| Value | Count | Frequency (%) | |
| 224 | 1 | 0.6% | |
| 223 | 1 | 0.6% | |
| 222 | 1 | 0.6% | |
| 221 | 1 | 0.6% | |
| 220 | 1 | 0.6% |
| Distinct count | 158 |
|---|---|
| Unique (%) | 95.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1604.121212121212 |
|---|---|
| Minimum | 62 |
| Maximum | 9632 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.3 KiB |
Quantile statistics
| Minimum | 62 |
|---|---|
| 5-th percentile | 225.2 |
| Q1 | 671 |
| median | 1310 |
| Q3 | 2125 |
| 95-th percentile | 4159.4 |
| Maximum | 9632 |
| Range | 9570 |
| Interquartile range (IQR) | 1454 |
Descriptive statistics
| Standard deviation | 1374.657406 |
|---|---|
| Coefficient of variation (CV) | 0.8569535744 |
| Kurtosis | 9.003218665 |
| Mean | 1604.121212 |
| Median Absolute Deviation (MAD) | 710 |
| Skewness | 2.406850391 |
| Sum | 264680 |
| Variance | 1889682.985 |
| Value | Count | Frequency (%) | |
| 1102 | 2 | 1.2% | |
| 848 | 2 | 1.2% | |
| 1682 | 2 | 1.2% | |
| 1775 | 2 | 1.2% | |
| 457 | 2 | 1.2% | |
| 1322 | 2 | 1.2% | |
| 1288 | 2 | 1.2% | |
| 9632 | 1 | 0.6% | |
| 2132 | 1 | 0.6% | |
| 1363 | 1 | 0.6% | |
| Other values (148) | 148 | 89.7% |
| Value | Count | Frequency (%) | |
| 62 | 1 | 0.6% | |
| 76 | 1 | 0.6% | |
| 102 | 1 | 0.6% | |
| 108 | 1 | 0.6% | |
| 143 | 1 | 0.6% |
| Value | Count | Frequency (%) | |
| 9632 | 1 | 0.6% | |
| 7230 | 1 | 0.6% | |
| 6880 | 1 | 0.6% | |
| 5732 | 1 | 0.6% | |
| 4825 | 1 | 0.6% |
| Distinct count | 159 |
|---|---|
| Unique (%) | 96.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1321.2424242424242 |
|---|---|
| Minimum | 41.0 |
| Maximum | 8002.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.3 KiB |
Quantile statistics
| Minimum | 41 |
|---|---|
| 5-th percentile | 196.8 |
| Q1 | 530 |
| median | 1073 |
| Q3 | 1746 |
| 95-th percentile | 3490.2 |
| Maximum | 8002 |
| Range | 7961 |
| Interquartile range (IQR) | 1216 |
Descriptive statistics
| Standard deviation | 1141.558163 |
|---|---|
| Coefficient of variation (CV) | 0.8640035633 |
| Kurtosis | 8.890345852 |
| Mean | 1321.242424 |
| Median Absolute Deviation (MAD) | 591 |
| Skewness | 2.381399645 |
| Sum | 218005 |
| Variance | 1303155.038 |
| Value | Count | Frequency (%) | |
| 1797 | 2 | 1.2% | |
| 650 | 2 | 1.2% | |
| 377 | 2 | 1.2% | |
| 429 | 2 | 1.2% | |
| 1610 | 2 | 1.2% | |
| 1694 | 2 | 1.2% | |
| 214 | 1 | 0.6% | |
| 204 | 1 | 0.6% | |
| 312 | 1 | 0.6% | |
| 279 | 1 | 0.6% | |
| Other values (149) | 149 | 90.3% |
| Value | Count | Frequency (%) | |
| 41 | 1 | 0.6% | |
| 65 | 1 | 0.6% | |
| 80 | 1 | 0.6% | |
| 88 | 1 | 0.6% | |
| 111 | 1 | 0.6% |
| Value | Count | Frequency (%) | |
| 8002 | 1 | 0.6% | |
| 5945 | 1 | 0.6% | |
| 5664 | 1 | 0.6% | |
| 4619 | 1 | 0.6% | |
| 4079 | 1 | 0.6% |
| Distinct count | 75 |
|---|---|
| Unique (%) | 45.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 37.93333333333333 |
|---|---|
| Minimum | 0.0 |
| Maximum | 240.0 |
| Zeros | 1 |
| Zeros (%) | 0.6% |
| Memory size | 1.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 5 |
| Q1 | 13 |
| median | 30 |
| Q3 | 52 |
| 95-th percentile | 101 |
| Maximum | 240 |
| Range | 240 |
| Interquartile range (IQR) | 39 |
Descriptive statistics
| Standard deviation | 33.98836482 |
|---|---|
| Coefficient of variation (CV) | 0.8960025875 |
| Kurtosis | 9.167947646 |
| Mean | 37.93333333 |
| Median Absolute Deviation (MAD) | 19 |
| Skewness | 2.374321392 |
| Sum | 6259 |
| Variance | 1155.208943 |
| Value | Count | Frequency (%) | |
| 12 | 7 | 4.2% | |
| 9 | 6 | 3.6% | |
| 61 | 5 | 3.0% | |
| 30 | 5 | 3.0% | |
| 50 | 5 | 3.0% | |
| 11 | 5 | 3.0% | |
| 20 | 4 | 2.4% | |
| 58 | 4 | 2.4% | |
| 7 | 4 | 2.4% | |
| 27 | 4 | 2.4% | |
| Other values (65) | 116 | 70.3% |
| Value | Count | Frequency (%) | |
| 0 | 1 | 0.6% | |
| 1 | 1 | 0.6% | |
| 2 | 2 | 1.2% | |
| 3 | 1 | 0.6% | |
| 4 | 3 | 1.8% |
| Value | Count | Frequency (%) | |
| 240 | 1 | 0.6% | |
| 181 | 1 | 0.6% | |
| 148 | 1 | 0.6% | |
| 146 | 1 | 0.6% | |
| 118 | 1 | 0.6% |
| Distinct count | 105 |
|---|---|
| Unique (%) | 63.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 72.8 |
|---|---|
| Minimum | 2.0 |
| Maximum | 437.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.3 KiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 7.2 |
| Q1 | 28 |
| median | 54 |
| Q3 | 93 |
| 95-th percentile | 170.6 |
| Maximum | 437 |
| Range | 435 |
| Interquartile range (IQR) | 65 |
Descriptive statistics
| Standard deviation | 68.8219867 |
|---|---|
| Coefficient of variation (CV) | 0.9453569602 |
| Kurtosis | 8.43677352 |
| Mean | 72.8 |
| Median Absolute Deviation (MAD) | 30 |
| Skewness | 2.494714978 |
| Sum | 12012 |
| Variance | 4736.465854 |
| Value | Count | Frequency (%) | |
| 37 | 4 | 2.4% | |
| 52 | 4 | 2.4% | |
| 27 | 4 | 2.4% | |
| 35 | 4 | 2.4% | |
| 28 | 4 | 2.4% | |
| 111 | 3 | 1.8% | |
| 54 | 3 | 1.8% | |
| 7 | 3 | 1.8% | |
| 81 | 3 | 1.8% | |
| 42 | 3 | 1.8% | |
| Other values (95) | 130 | 78.8% |
| Value | Count | Frequency (%) | |
| 2 | 1 | 0.6% | |
| 3 | 1 | 0.6% | |
| 4 | 1 | 0.6% | |
| 5 | 2 | 1.2% | |
| 6 | 1 | 0.6% |
| Value | Count | Frequency (%) | |
| 437 | 1 | 0.6% | |
| 388 | 1 | 0.6% | |
| 336 | 1 | 0.6% | |
| 303 | 1 | 0.6% | |
| 292 | 1 | 0.6% |
| Distinct count | 40 |
|---|---|
| Unique (%) | 24.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 14.460606060606061 |
|---|---|
| Minimum | 0.0 |
| Maximum | 75.0 |
| Zeros | 4 |
| Zeros (%) | 2.4% |
| Memory size | 1.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 5 |
| median | 11 |
| Q3 | 20 |
| 95-th percentile | 37.6 |
| Maximum | 75 |
| Range | 75 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 13.7917866 |
|---|---|
| Coefficient of variation (CV) | 0.9537488639 |
| Kurtosis | 6.194060307 |
| Mean | 14.46060606 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | 2.181310639 |
| Sum | 2386 |
| Variance | 190.2133777 |
| Value | Count | Frequency (%) | |
| 6 | 10 | 6.1% | |
| 9 | 10 | 6.1% | |
| 4 | 9 | 5.5% | |
| 1 | 8 | 4.8% | |
| 8 | 8 | 4.8% | |
| 5 | 8 | 4.8% | |
| 2 | 8 | 4.8% | |
| 17 | 8 | 4.8% | |
| 12 | 7 | 4.2% | |
| 11 | 6 | 3.6% | |
| Other values (30) | 83 | 50.3% |
| Value | Count | Frequency (%) | |
| 0 | 4 | 2.4% | |
| 1 | 8 | 4.8% | |
| 2 | 8 | 4.8% | |
| 3 | 6 | 3.6% | |
| 4 | 9 | 5.5% |
| Value | Count | Frequency (%) | |
| 75 | 1 | 0.6% | |
| 73 | 1 | 0.6% | |
| 72 | 1 | 0.6% | |
| 69 | 1 | 0.6% | |
| 54 | 1 | 0.6% |
| Distinct count | 57 |
|---|---|
| Unique (%) | 34.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 24.636363636363637 |
|---|---|
| Minimum | 0.0 |
| Maximum | 143.0 |
| Zeros | 1 |
| Zeros (%) | 0.6% |
| Memory size | 1.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 11 |
| median | 20 |
| Q3 | 31 |
| 95-th percentile | 59.6 |
| Maximum | 143 |
| Range | 143 |
| Interquartile range (IQR) | 20 |
Descriptive statistics
| Standard deviation | 21.32160559 |
|---|---|
| Coefficient of variation (CV) | 0.8654526252 |
| Kurtosis | 9.250856078 |
| Mean | 24.63636364 |
| Median Absolute Deviation (MAD) | 9 |
| Skewness | 2.524430657 |
| Sum | 4065 |
| Variance | 454.6108647 |
| Value | Count | Frequency (%) | |
| 8 | 10 | 6.1% | |
| 28 | 6 | 3.6% | |
| 17 | 6 | 3.6% | |
| 23 | 6 | 3.6% | |
| 13 | 6 | 3.6% | |
| 12 | 5 | 3.0% | |
| 21 | 5 | 3.0% | |
| 3 | 5 | 3.0% | |
| 11 | 5 | 3.0% | |
| 14 | 5 | 3.0% | |
| Other values (47) | 106 | 64.2% |
| Value | Count | Frequency (%) | |
| 0 | 1 | 0.6% | |
| 1 | 4 | 2.4% | |
| 2 | 3 | 1.8% | |
| 3 | 5 | 3.0% | |
| 4 | 3 | 1.8% |
| Value | Count | Frequency (%) | |
| 143 | 1 | 0.6% | |
| 122 | 1 | 0.6% | |
| 110 | 1 | 0.6% | |
| 93 | 1 | 0.6% | |
| 89 | 1 | 0.6% |
top_location
Real number (ℝ≥0)
| Distinct count | 95 |
|---|---|
| Unique (%) | 57.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 56.21818181818182 |
|---|---|
| Minimum | 1 |
| Maximum | 113 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.3 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 6.2 |
| Q1 | 30 |
| median | 56 |
| Q3 | 79 |
| 95-th percentile | 105.8 |
| Maximum | 113 |
| Range | 112 |
| Interquartile range (IQR) | 49 |
Descriptive statistics
| Standard deviation | 31.44256722 |
|---|---|
| Coefficient of variation (CV) | 0.5592953418 |
| Kurtosis | -1.065978092 |
| Mean | 56.21818182 |
| Median Absolute Deviation (MAD) | 24 |
| Skewness | -0.007466208193 |
| Sum | 9276 |
| Variance | 988.6350333 |
| Value | Count | Frequency (%) | |
| 56 | 14 | 8.5% | |
| 72 | 12 | 7.3% | |
| 18 | 5 | 3.0% | |
| 17 | 5 | 3.0% | |
| 79 | 5 | 3.0% | |
| 5 | 4 | 2.4% | |
| 101 | 4 | 2.4% | |
| 78 | 4 | 2.4% | |
| 12 | 4 | 2.4% | |
| 26 | 3 | 1.8% | |
| Other values (85) | 105 | 63.6% |
| Value | Count | Frequency (%) | |
| 1 | 1 | 0.6% | |
| 2 | 1 | 0.6% | |
| 3 | 1 | 0.6% | |
| 4 | 1 | 0.6% | |
| 5 | 4 | 2.4% |
| Value | Count | Frequency (%) | |
| 113 | 1 | 0.6% | |
| 112 | 1 | 0.6% | |
| 111 | 3 | 1.8% | |
| 109 | 1 | 0.6% | |
| 108 | 1 | 0.6% |
user_gender
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 1.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 KiB |
| 1 | |
|---|---|
| 0 |
| Value | Count | Frequency (%) | |
| 1 | 86 | 52.1% | |
| 0 | 79 | 47.9% |
| Distinct count | 158 |
|---|---|
| Unique (%) | 95.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1604.121212121212 |
|---|---|
| Minimum | 62 |
| Maximum | 9632 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.3 KiB |
Quantile statistics
| Minimum | 62 |
|---|---|
| 5-th percentile | 225.2 |
| Q1 | 671 |
| median | 1310 |
| Q3 | 2125 |
| 95-th percentile | 4159.4 |
| Maximum | 9632 |
| Range | 9570 |
| Interquartile range (IQR) | 1454 |
Descriptive statistics
| Standard deviation | 1374.657406 |
|---|---|
| Coefficient of variation (CV) | 0.8569535744 |
| Kurtosis | 9.003218665 |
| Mean | 1604.121212 |
| Median Absolute Deviation (MAD) | 710 |
| Skewness | 2.406850391 |
| Sum | 264680 |
| Variance | 1889682.985 |
| Value | Count | Frequency (%) | |
| 1102 | 2 | 1.2% | |
| 848 | 2 | 1.2% | |
| 1682 | 2 | 1.2% | |
| 1775 | 2 | 1.2% | |
| 457 | 2 | 1.2% | |
| 1322 | 2 | 1.2% | |
| 1288 | 2 | 1.2% | |
| 9632 | 1 | 0.6% | |
| 2132 | 1 | 0.6% | |
| 1363 | 1 | 0.6% | |
| Other values (148) | 148 | 89.7% |
| Value | Count | Frequency (%) | |
| 62 | 1 | 0.6% | |
| 76 | 1 | 0.6% | |
| 102 | 1 | 0.6% | |
| 108 | 1 | 0.6% | |
| 143 | 1 | 0.6% |
| Value | Count | Frequency (%) | |
| 9632 | 1 | 0.6% | |
| 7230 | 1 | 0.6% | |
| 6880 | 1 | 0.6% | |
| 5732 | 1 | 0.6% | |
| 4825 | 1 | 0.6% |
| Distinct count | 158 |
|---|---|
| Unique (%) | 95.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1604.121212121212 |
|---|---|
| Minimum | 62 |
| Maximum | 9632 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.3 KiB |
Quantile statistics
| Minimum | 62 |
|---|---|
| 5-th percentile | 225.2 |
| Q1 | 671 |
| median | 1310 |
| Q3 | 2125 |
| 95-th percentile | 4159.4 |
| Maximum | 9632 |
| Range | 9570 |
| Interquartile range (IQR) | 1454 |
Descriptive statistics
| Standard deviation | 1374.657406 |
|---|---|
| Coefficient of variation (CV) | 0.8569535744 |
| Kurtosis | 9.003218665 |
| Mean | 1604.121212 |
| Median Absolute Deviation (MAD) | 710 |
| Skewness | 2.406850391 |
| Sum | 264680 |
| Variance | 1889682.985 |
| Value | Count | Frequency (%) | |
| 1102 | 2 | 1.2% | |
| 848 | 2 | 1.2% | |
| 1682 | 2 | 1.2% | |
| 1775 | 2 | 1.2% | |
| 457 | 2 | 1.2% | |
| 1322 | 2 | 1.2% | |
| 1288 | 2 | 1.2% | |
| 9632 | 1 | 0.6% | |
| 2132 | 1 | 0.6% | |
| 1363 | 1 | 0.6% | |
| Other values (148) | 148 | 89.7% |
| Value | Count | Frequency (%) | |
| 62 | 1 | 0.6% | |
| 76 | 1 | 0.6% | |
| 102 | 1 | 0.6% | |
| 108 | 1 | 0.6% | |
| 143 | 1 | 0.6% |
| Value | Count | Frequency (%) | |
| 9632 | 1 | 0.6% | |
| 7230 | 1 | 0.6% | |
| 6880 | 1 | 0.6% | |
| 5732 | 1 | 0.6% | |
| 4825 | 1 | 0.6% |
days_active
Real number (ℝ≥0)
| Distinct count | 92 |
|---|---|
| Unique (%) | 55.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 83.18787878787879 |
|---|---|
| Minimum | 11 |
| Maximum | 256 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.3 KiB |
Quantile statistics
| Minimum | 11 |
|---|---|
| 5-th percentile | 27.2 |
| Q1 | 62 |
| median | 75 |
| Q3 | 108 |
| 95-th percentile | 151.6 |
| Maximum | 256 |
| Range | 245 |
| Interquartile range (IQR) | 46 |
Descriptive statistics
| Standard deviation | 38.2709512 |
|---|---|
| Coefficient of variation (CV) | 0.4600544185 |
| Kurtosis | 1.931411572 |
| Mean | 83.18787879 |
| Median Absolute Deviation (MAD) | 19 |
| Skewness | 0.9476913839 |
| Sum | 13726 |
| Variance | 1464.665706 |
| Value | Count | Frequency (%) | |
| 75 | 8 | 4.8% | |
| 71 | 7 | 4.2% | |
| 63 | 5 | 3.0% | |
| 62 | 4 | 2.4% | |
| 76 | 4 | 2.4% | |
| 67 | 4 | 2.4% | |
| 68 | 4 | 2.4% | |
| 110 | 3 | 1.8% | |
| 102 | 3 | 1.8% | |
| 124 | 3 | 1.8% | |
| Other values (82) | 120 | 72.7% |
| Value | Count | Frequency (%) | |
| 11 | 1 | 0.6% | |
| 13 | 1 | 0.6% | |
| 16 | 1 | 0.6% | |
| 19 | 1 | 0.6% | |
| 21 | 2 | 1.2% |
| Value | Count | Frequency (%) | |
| 256 | 1 | 0.6% | |
| 188 | 1 | 0.6% | |
| 172 | 1 | 0.6% | |
| 171 | 1 | 0.6% | |
| 168 | 1 | 0.6% |
| Distinct count | 148 |
|---|---|
| Unique (%) | 89.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 279.8424242424242 |
|---|---|
| Minimum | 1.0 |
| Maximum | 959.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.3 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 32.2 |
| Q1 | 111 |
| median | 235 |
| Q3 | 390 |
| 95-th percentile | 701.8 |
| Maximum | 959 |
| Range | 958 |
| Interquartile range (IQR) | 279 |
Descriptive statistics
| Standard deviation | 218.0377275 |
|---|---|
| Coefficient of variation (CV) | 0.7791446494 |
| Kurtosis | 0.8456860898 |
| Mean | 279.8424242 |
| Median Absolute Deviation (MAD) | 137 |
| Skewness | 1.069614434 |
| Sum | 46174 |
| Variance | 47540.45063 |
| Value | Count | Frequency (%) | |
| 33 | 3 | 1.8% | |
| 48 | 2 | 1.2% | |
| 121 | 2 | 1.2% | |
| 32 | 2 | 1.2% | |
| 269 | 2 | 1.2% | |
| 44 | 2 | 1.2% | |
| 361 | 2 | 1.2% | |
| 333 | 2 | 1.2% | |
| 38 | 2 | 1.2% | |
| 330 | 2 | 1.2% | |
| Other values (138) | 144 | 87.3% |
| Value | Count | Frequency (%) | |
| 1 | 2 | 1.2% | |
| 8 | 1 | 0.6% | |
| 10 | 1 | 0.6% | |
| 13 | 1 | 0.6% | |
| 15 | 1 | 0.6% |
| Value | Count | Frequency (%) | |
| 959 | 1 | 0.6% | |
| 948 | 1 | 0.6% | |
| 896 | 1 | 0.6% | |
| 891 | 1 | 0.6% | |
| 880 | 1 | 0.6% |
| Distinct count | 29 |
|---|---|
| Unique (%) | 17.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.751515151515152 |
|---|---|
| Minimum | 0.0 |
| Maximum | 33.0 |
| Zeros | 11 |
| Zeros (%) | 6.7% |
| Memory size | 1.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 2 |
| median | 6 |
| Q3 | 11 |
| 95-th percentile | 22.6 |
| Maximum | 33 |
| Range | 33 |
| Interquartile range (IQR) | 9 |
Descriptive statistics
| Standard deviation | 6.938234523 |
|---|---|
| Coefficient of variation (CV) | 0.8950810761 |
| Kurtosis | 1.798577324 |
| Mean | 7.751515152 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | 1.376526639 |
| Sum | 1279 |
| Variance | 48.1390983 |
| Value | Count | Frequency (%) | |
| 2 | 19 | 11.5% | |
| 4 | 15 | 9.1% | |
| 1 | 13 | 7.9% | |
| 9 | 13 | 7.9% | |
| 0 | 11 | 6.7% | |
| 3 | 11 | 6.7% | |
| 7 | 10 | 6.1% | |
| 6 | 10 | 6.1% | |
| 8 | 8 | 4.8% | |
| 12 | 8 | 4.8% | |
| Other values (19) | 47 | 28.5% |
| Value | Count | Frequency (%) | |
| 0 | 11 | 6.7% | |
| 1 | 13 | 7.9% | |
| 2 | 19 | 11.5% | |
| 3 | 11 | 6.7% | |
| 4 | 15 | 9.1% |
| Value | Count | Frequency (%) | |
| 33 | 1 | 0.6% | |
| 31 | 1 | 0.6% | |
| 30 | 1 | 0.6% | |
| 26 | 3 | 1.8% | |
| 25 | 1 | 0.6% |
| Distinct count | 45 |
|---|---|
| Unique (%) | 27.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.351515151515152 |
|---|---|
| Minimum | 0.0 |
| Maximum | 56.0 |
| Zeros | 3 |
| Zeros (%) | 1.8% |
| Memory size | 1.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 5 |
| median | 12 |
| Q3 | 20 |
| 95-th percentile | 41.8 |
| Maximum | 56 |
| Range | 56 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 12.53424872 |
|---|---|
| Coefficient of variation (CV) | 0.816482842 |
| Kurtosis | 0.799669563 |
| Mean | 15.35151515 |
| Median Absolute Deviation (MAD) | 7 |
| Skewness | 1.11769071 |
| Sum | 2533 |
| Variance | 157.107391 |
| Value | Count | Frequency (%) | |
| 5 | 12 | 7.3% | |
| 1 | 11 | 6.7% | |
| 4 | 10 | 6.1% | |
| 9 | 9 | 5.5% | |
| 6 | 9 | 5.5% | |
| 20 | 8 | 4.8% | |
| 13 | 7 | 4.2% | |
| 12 | 7 | 4.2% | |
| 14 | 6 | 3.6% | |
| 11 | 6 | 3.6% | |
| Other values (35) | 80 | 48.5% |
| Value | Count | Frequency (%) | |
| 0 | 3 | 1.8% | |
| 1 | 11 | 6.7% | |
| 2 | 4 | 2.4% | |
| 3 | 4 | 2.4% | |
| 4 | 10 | 6.1% |
| Value | Count | Frequency (%) | |
| 56 | 1 | 0.6% | |
| 52 | 1 | 0.6% | |
| 50 | 2 | 1.2% | |
| 48 | 1 | 0.6% | |
| 47 | 1 | 0.6% |
| Distinct count | 17 |
|---|---|
| Unique (%) | 10.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.187878787878788 |
|---|---|
| Minimum | 0.0 |
| Maximum | 17.0 |
| Zeros | 32 |
| Zeros (%) | 19.4% |
| Memory size | 1.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 2 |
| Q3 | 5 |
| 95-th percentile | 9.8 |
| Maximum | 17 |
| Range | 17 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 3.325048833 |
|---|---|
| Coefficient of variation (CV) | 1.043028626 |
| Kurtosis | 3.185389525 |
| Mean | 3.187878788 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 1.646781354 |
| Sum | 526 |
| Variance | 11.05594974 |
| Value | Count | Frequency (%) | |
| 1 | 35 | 21.2% | |
| 0 | 32 | 19.4% | |
| 3 | 22 | 13.3% | |
| 2 | 20 | 12.1% | |
| 5 | 14 | 8.5% | |
| 6 | 11 | 6.7% | |
| 4 | 10 | 6.1% | |
| 8 | 5 | 3.0% | |
| 7 | 5 | 3.0% | |
| 9 | 2 | 1.2% | |
| Other values (7) | 9 | 5.5% |
| Value | Count | Frequency (%) | |
| 0 | 32 | 19.4% | |
| 1 | 35 | 21.2% | |
| 2 | 20 | 12.1% | |
| 3 | 22 | 13.3% | |
| 4 | 10 | 6.1% |
| Value | Count | Frequency (%) | |
| 17 | 1 | 0.6% | |
| 16 | 1 | 0.6% | |
| 14 | 1 | 0.6% | |
| 13 | 2 | 1.2% | |
| 12 | 1 | 0.6% |
| Distinct count | 20 |
|---|---|
| Unique (%) | 12.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.387878787878788 |
|---|---|
| Minimum | 0.0 |
| Maximum | 28.0 |
| Zeros | 27 |
| Zeros (%) | 16.4% |
| Memory size | 1.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 4 |
| Q3 | 8 |
| 95-th percentile | 14.8 |
| Maximum | 28 |
| Range | 28 |
| Interquartile range (IQR) | 7 |
Descriptive statistics
| Standard deviation | 5.097330577 |
|---|---|
| Coefficient of variation (CV) | 0.9460737291 |
| Kurtosis | 2.517558508 |
| Mean | 5.387878788 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 1.336787808 |
| Sum | 889 |
| Variance | 25.98277901 |
| Value | Count | Frequency (%) | |
| 0 | 27 | 16.4% | |
| 1 | 20 | 12.1% | |
| 3 | 17 | 10.3% | |
| 7 | 13 | 7.9% | |
| 8 | 12 | 7.3% | |
| 2 | 12 | 7.3% | |
| 5 | 11 | 6.7% | |
| 4 | 10 | 6.1% | |
| 6 | 7 | 4.2% | |
| 12 | 6 | 3.6% | |
| Other values (10) | 30 | 18.2% |
| Value | Count | Frequency (%) | |
| 0 | 27 | 16.4% | |
| 1 | 20 | 12.1% | |
| 2 | 12 | 7.3% | |
| 3 | 17 | 10.3% | |
| 4 | 10 | 6.1% |
| Value | Count | Frequency (%) | |
| 28 | 1 | 0.6% | |
| 24 | 1 | 0.6% | |
| 22 | 1 | 0.6% | |
| 16 | 2 | 1.2% | |
| 15 | 4 | 2.4% |
playlisted_ratio
Real number (ℝ≥0)
| Distinct count | 162 |
|---|---|
| Unique (%) | 98.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.02820802409884897 |
|---|---|
| Minimum | 0.0 |
| Maximum | 0.08641975308641975 |
| Zeros | 1 |
| Zeros (%) | 0.6% |
| Memory size | 1.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.01806598778 |
| Q1 | 0.0243902439 |
| median | 0.02810650888 |
| Q3 | 0.03196347032 |
| 95-th percentile | 0.03675886194 |
| Maximum | 0.08641975309 |
| Range | 0.08641975309 |
| Interquartile range (IQR) | 0.007573226417 |
Descriptive statistics
| Standard deviation | 0.007633865906 |
|---|---|
| Coefficient of variation (CV) | 0.2706274597 |
| Kurtosis | 20.56221127 |
| Mean | 0.0282080241 |
| Median Absolute Deviation (MAD) | 0.003856961444 |
| Skewness | 2.318122225 |
| Sum | 4.654323976 |
| Variance | 5.827590867e-05 |
| Value | Count | Frequency (%) | |
| 0.02380952381 | 3 | 1.8% | |
| 0.03571428571 | 2 | 1.2% | |
| 0.0241301908 | 1 | 0.6% | |
| 0.03035878565 | 1 | 0.6% | |
| 0.03004291845 | 1 | 0.6% | |
| 0.03403141361 | 1 | 0.6% | |
| 0.025 | 1 | 0.6% | |
| 0.02194656489 | 1 | 0.6% | |
| 0.03366696997 | 1 | 0.6% | |
| 0.02312138728 | 1 | 0.6% | |
| Other values (152) | 152 | 92.1% |
| Value | Count | Frequency (%) | |
| 0 | 1 | 0.6% | |
| 0.01129943503 | 1 | 0.6% | |
| 0.01335311573 | 1 | 0.6% | |
| 0.01438848921 | 1 | 0.6% | |
| 0.01463414634 | 1 | 0.6% |
| Value | Count | Frequency (%) | |
| 0.08641975309 | 1 | 0.6% | |
| 0.04452054795 | 1 | 0.6% | |
| 0.04115226337 | 1 | 0.6% | |
| 0.03972687772 | 1 | 0.6% | |
| 0.03942857143 | 1 | 0.6% |
| Distinct count | 165 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.05488629303398286 |
|---|---|
| Minimum | 0.02108433734939759 |
| Maximum | 0.1130952380952381 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.3 KiB |
Quantile statistics
| Minimum | 0.02108433735 |
|---|---|
| 5-th percentile | 0.03496924486 |
| Q1 | 0.04572907679 |
| median | 0.05119047619 |
| Q3 | 0.05862831858 |
| 95-th percentile | 0.09368205569 |
| Maximum | 0.1130952381 |
| Range | 0.09201090075 |
| Interquartile range (IQR) | 0.01289924179 |
Descriptive statistics
| Standard deviation | 0.0168197903 |
|---|---|
| Coefficient of variation (CV) | 0.3064479193 |
| Kurtosis | 2.127315874 |
| Mean | 0.05488629303 |
| Median Absolute Deviation (MAD) | 0.00625633232 |
| Skewness | 1.347780081 |
| Sum | 9.056238351 |
| Variance | 0.0002829053458 |
| Value | Count | Frequency (%) | |
| 0.03703703704 | 1 | 0.6% | |
| 0.04759493671 | 1 | 0.6% | |
| 0.05 | 1 | 0.6% | |
| 0.07962697274 | 1 | 0.6% | |
| 0.04848181932 | 1 | 0.6% | |
| 0.03203342618 | 1 | 0.6% | |
| 0.05170239596 | 1 | 0.6% | |
| 0.06068268015 | 1 | 0.6% | |
| 0.04600638978 | 1 | 0.6% | |
| 0.05545722714 | 1 | 0.6% | |
| Other values (155) | 155 | 93.9% |
| Value | Count | Frequency (%) | |
| 0.02108433735 | 1 | 0.6% | |
| 0.02304147465 | 1 | 0.6% | |
| 0.02450980392 | 1 | 0.6% | |
| 0.02551020408 | 1 | 0.6% | |
| 0.02877697842 | 1 | 0.6% |
| Value | Count | Frequency (%) | |
| 0.1130952381 | 1 | 0.6% | |
| 0.1118210863 | 1 | 0.6% | |
| 0.1070878274 | 1 | 0.6% | |
| 0.1038798498 | 1 | 0.6% | |
| 0.09821428571 | 1 | 0.6% |
| Distinct count | 158 |
|---|---|
| Unique (%) | 95.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.011303402104294612 |
|---|---|
| Minimum | 0.0 |
| Maximum | 0.0374331550802139 |
| Zeros | 4 |
| Zeros (%) | 2.4% |
| Memory size | 1.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.004023045267 |
| Q1 | 0.007310704961 |
| median | 0.009463722397 |
| Q3 | 0.0124137931 |
| 95-th percentile | 0.0310765962 |
| Maximum | 0.03743315508 |
| Range | 0.03743315508 |
| Interquartile range (IQR) | 0.005103088143 |
Descriptive statistics
| Standard deviation | 0.007302483765 |
|---|---|
| Coefficient of variation (CV) | 0.6460429964 |
| Kurtosis | 3.769201087 |
| Mean | 0.0113034021 |
| Median Absolute Deviation (MAD) | 0.002404898868 |
| Skewness | 1.937214341 |
| Sum | 1.865061347 |
| Variance | 5.332626914e-05 |
| Value | Count | Frequency (%) | |
| 0 | 4 | 2.4% | |
| 0.005952380952 | 2 | 1.2% | |
| 0.008898776418 | 2 | 1.2% | |
| 0.007936507937 | 2 | 1.2% | |
| 0.01277955272 | 2 | 1.2% | |
| 0.01308900524 | 1 | 0.6% | |
| 0.008090614887 | 1 | 0.6% | |
| 0.009748172218 | 1 | 0.6% | |
| 0.01147776184 | 1 | 0.6% | |
| 0.01006336191 | 1 | 0.6% | |
| Other values (148) | 148 | 89.7% |
| Value | Count | Frequency (%) | |
| 0 | 4 | 2.4% | |
| 0.002325581395 | 1 | 0.6% | |
| 0.00365408039 | 1 | 0.6% | |
| 0.003816793893 | 1 | 0.6% | |
| 0.00390625 | 1 | 0.6% |
| Value | Count | Frequency (%) | |
| 0.03743315508 | 1 | 0.6% | |
| 0.03686635945 | 1 | 0.6% | |
| 0.03427419355 | 1 | 0.6% | |
| 0.03413400759 | 1 | 0.6% | |
| 0.03324468085 | 1 | 0.6% |
| Distinct count | 165 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 18.058769331860425 |
|---|---|
| Minimum | 0.7735849056603774 |
| Maximum | 105.55 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.3 KiB |
Quantile statistics
| Minimum | 0.7735849057 |
|---|---|
| 5-th percentile | 2.668035692 |
| Q1 | 7.54 |
| median | 12.33333333 |
| Q3 | 23.40789474 |
| 95-th percentile | 49.39680874 |
| Maximum | 105.55 |
| Range | 104.7764151 |
| Interquartile range (IQR) | 15.86789474 |
Descriptive statistics
| Standard deviation | 16.46408399 |
|---|---|
| Coefficient of variation (CV) | 0.9116946835 |
| Kurtosis | 5.854022416 |
| Mean | 18.05876933 |
| Median Absolute Deviation (MAD) | 7.137254902 |
| Skewness | 2.079348662 |
| Sum | 2979.69694 |
| Variance | 271.0660616 |
| Value | Count | Frequency (%) | |
| 17.94444444 | 1 | 0.6% | |
| 12.78225806 | 1 | 0.6% | |
| 11.90066225 | 1 | 0.6% | |
| 32.87272727 | 1 | 0.6% | |
| 11.76470588 | 1 | 0.6% | |
| 8.293650794 | 1 | 0.6% | |
| 8.409638554 | 1 | 0.6% | |
| 19.47058824 | 1 | 0.6% | |
| 30.90151515 | 1 | 0.6% | |
| 2.256410256 | 1 | 0.6% | |
| Other values (155) | 155 | 93.9% |
| Value | Count | Frequency (%) | |
| 0.7735849057 | 1 | 0.6% | |
| 1.203703704 | 1 | 0.6% | |
| 1.211180124 | 1 | 0.6% | |
| 1.219298246 | 1 | 0.6% | |
| 1.241935484 | 1 | 0.6% |
| Value | Count | Frequency (%) | |
| 105.55 | 1 | 0.6% | |
| 74.5 | 1 | 0.6% | |
| 70.77380952 | 1 | 0.6% | |
| 69.92592593 | 1 | 0.6% | |
| 66.21428571 | 1 | 0.6% |
| Distinct count | 165 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 21.903938194055314 |
|---|---|
| Minimum | 1.169811320754717 |
| Maximum | 123.2 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.3 KiB |
Quantile statistics
| Minimum | 1.169811321 |
|---|---|
| 5-th percentile | 3.22349346 |
| Q1 | 9.14 |
| median | 15.28225806 |
| Q3 | 28.14102564 |
| 95-th percentile | 59.06045902 |
| Maximum | 123.2 |
| Range | 122.0301887 |
| Interquartile range (IQR) | 19.00102564 |
Descriptive statistics
| Standard deviation | 19.71432324 |
|---|---|
| Coefficient of variation (CV) | 0.9000355584 |
| Kurtosis | 5.451594162 |
| Mean | 21.90393819 |
| Median Absolute Deviation (MAD) | 8.498258065 |
| Skewness | 2.039149221 |
| Sum | 3614.149802 |
| Variance | 388.654541 |
| Value | Count | Frequency (%) | |
| 21.48611111 | 1 | 0.6% | |
| 11.21052632 | 1 | 0.6% | |
| 19.03448276 | 1 | 0.6% | |
| 30.6 | 1 | 0.6% | |
| 14.27906977 | 1 | 0.6% | |
| 36.5530303 | 1 | 0.6% | |
| 15.28225806 | 1 | 0.6% | |
| 12.15753425 | 1 | 0.6% | |
| 10.10185185 | 1 | 0.6% | |
| 49.23809524 | 1 | 0.6% | |
| Other values (155) | 155 | 93.9% |
| Value | Count | Frequency (%) | |
| 1.169811321 | 1 | 0.6% | |
| 1.354037267 | 1 | 0.6% | |
| 1.407407407 | 1 | 0.6% | |
| 1.526315789 | 1 | 0.6% | |
| 1.685483871 | 1 | 0.6% |
| Value | Count | Frequency (%) | |
| 123.2 | 1 | 0.6% | |
| 92.4516129 | 1 | 0.6% | |
| 86.07142857 | 1 | 0.6% | |
| 84.9382716 | 1 | 0.6% | |
| 78.71428571 | 1 | 0.6% |
| Distinct count | 135 |
|---|---|
| Unique (%) | 81.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 346.09090909090907 |
|---|---|
| Minimum | 37 |
| Maximum | 1179 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.3 KiB |
Quantile statistics
| Minimum | 37 |
|---|---|
| 5-th percentile | 142 |
| Q1 | 228 |
| median | 321 |
| Q3 | 431 |
| 95-th percentile | 640.8 |
| Maximum | 1179 |
| Range | 1142 |
| Interquartile range (IQR) | 203 |
Descriptive statistics
| Standard deviation | 166.8964853 |
|---|---|
| Coefficient of variation (CV) | 0.4822330807 |
| Kurtosis | 4.161622197 |
| Mean | 346.0909091 |
| Median Absolute Deviation (MAD) | 98 |
| Skewness | 1.513614716 |
| Sum | 57105 |
| Variance | 27854.43681 |
| Value | Count | Frequency (%) | |
| 432 | 4 | 2.4% | |
| 211 | 4 | 2.4% | |
| 329 | 3 | 1.8% | |
| 232 | 3 | 1.8% | |
| 381 | 3 | 1.8% | |
| 370 | 2 | 1.2% | |
| 216 | 2 | 1.2% | |
| 457 | 2 | 1.2% | |
| 326 | 2 | 1.2% | |
| 339 | 2 | 1.2% | |
| Other values (125) | 138 | 83.6% |
| Value | Count | Frequency (%) | |
| 37 | 1 | 0.6% | |
| 87 | 1 | 0.6% | |
| 89 | 1 | 0.6% | |
| 108 | 1 | 0.6% | |
| 125 | 1 | 0.6% |
| Value | Count | Frequency (%) | |
| 1179 | 1 | 0.6% | |
| 904 | 1 | 0.6% | |
| 871 | 1 | 0.6% | |
| 817 | 1 | 0.6% | |
| 816 | 1 | 0.6% |
session_count
Real number (ℝ≥0)
| Distinct count | 45 |
|---|---|
| Unique (%) | 27.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 17.175757575757576 |
|---|---|
| Minimum | 1 |
| Maximum | 107 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.3 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 8 |
| median | 13 |
| Q3 | 21 |
| 95-th percentile | 40.4 |
| Maximum | 107 |
| Range | 106 |
| Interquartile range (IQR) | 13 |
Descriptive statistics
| Standard deviation | 15.82023693 |
|---|---|
| Coefficient of variation (CV) | 0.9210794261 |
| Kurtosis | 10.11839628 |
| Mean | 17.17575758 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | 2.785708026 |
| Sum | 2834 |
| Variance | 250.2798965 |
| Value | Count | Frequency (%) | |
| 6 | 11 | 6.7% | |
| 10 | 11 | 6.7% | |
| 15 | 9 | 5.5% | |
| 7 | 9 | 5.5% | |
| 12 | 8 | 4.8% | |
| 11 | 7 | 4.2% | |
| 4 | 7 | 4.2% | |
| 8 | 7 | 4.2% | |
| 9 | 7 | 4.2% | |
| 3 | 6 | 3.6% | |
| Other values (35) | 83 | 50.3% |
| Value | Count | Frequency (%) | |
| 1 | 4 | 2.4% | |
| 3 | 6 | 3.6% | |
| 4 | 7 | 4.2% | |
| 5 | 4 | 2.4% | |
| 6 | 11 | 6.7% |
| Value | Count | Frequency (%) | |
| 107 | 1 | 0.6% | |
| 86 | 1 | 0.6% | |
| 76 | 2 | 1.2% | |
| 71 | 1 | 0.6% | |
| 63 | 1 | 0.6% |
| Distinct count | 161 |
|---|---|
| Unique (%) | 97.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 100.98616922792375 |
|---|---|
| Minimum | 15.5 |
| Maximum | 334.8888888888889 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.3 KiB |
Quantile statistics
| Minimum | 15.5 |
|---|---|
| 5-th percentile | 42.59090909 |
| Q1 | 69.95 |
| median | 92.88888889 |
| Q3 | 119.625 |
| 95-th percentile | 181.0133333 |
| Maximum | 334.8888889 |
| Range | 319.3888889 |
| Interquartile range (IQR) | 49.675 |
Descriptive statistics
| Standard deviation | 46.33954567 |
|---|---|
| Coefficient of variation (CV) | 0.4588702198 |
| Kurtosis | 4.342145789 |
| Mean | 100.9861692 |
| Median Absolute Deviation (MAD) | 24.97222222 |
| Skewness | 1.53284204 |
| Sum | 16662.71792 |
| Variance | 2147.353493 |
| Value | Count | Frequency (%) | |
| 51.66666667 | 2 | 1.2% | |
| 91 | 2 | 1.2% | |
| 61.33333333 | 2 | 1.2% | |
| 111 | 2 | 1.2% | |
| 156.6666667 | 1 | 0.6% | |
| 36 | 1 | 0.6% | |
| 125.6666667 | 1 | 0.6% | |
| 56.53846154 | 1 | 0.6% | |
| 77.09090909 | 1 | 0.6% | |
| 41.61111111 | 1 | 0.6% | |
| Other values (151) | 151 | 91.5% |
| Value | Count | Frequency (%) | |
| 15.5 | 1 | 0.6% | |
| 25.33333333 | 1 | 0.6% | |
| 29 | 1 | 0.6% | |
| 36 | 1 | 0.6% | |
| 40.12 | 1 | 0.6% |
| Value | Count | Frequency (%) | |
| 334.8888889 | 1 | 0.6% | |
| 259 | 1 | 0.6% | |
| 246.4 | 1 | 0.6% | |
| 235.375 | 1 | 0.6% | |
| 214.9 | 1 | 0.6% |
sessions_per_day
Real number (ℝ≥0)
| Distinct count | 156 |
|---|---|
| Unique (%) | 94.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.23248584287136917 |
|---|---|
| Minimum | 0.023809523809523808 |
| Maximum | 1.2459016393442623 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.3 KiB |
Quantile statistics
| Minimum | 0.02380952381 |
|---|---|
| 5-th percentile | 0.04685714286 |
| Q1 | 0.09677419355 |
| median | 0.1690140845 |
| Q3 | 0.2857142857 |
| 95-th percentile | 0.6228571429 |
| Maximum | 1.245901639 |
| Range | 1.222092116 |
| Interquartile range (IQR) | 0.1889400922 |
Descriptive statistics
| Standard deviation | 0.2096834475 |
|---|---|
| Coefficient of variation (CV) | 0.901919209 |
| Kurtosis | 6.21988112 |
| Mean | 0.2324858429 |
| Median Absolute Deviation (MAD) | 0.08568075117 |
| Skewness | 2.241243262 |
| Sum | 38.36016407 |
| Variance | 0.04396714816 |
| Value | Count | Frequency (%) | |
| 0.1470588235 | 3 | 1.8% | |
| 0.323943662 | 2 | 1.2% | |
| 0.109375 | 2 | 1.2% | |
| 0.1176470588 | 2 | 1.2% | |
| 0.07692307692 | 2 | 1.2% | |
| 0.2 | 2 | 1.2% | |
| 0.1066666667 | 2 | 1.2% | |
| 0.07407407407 | 2 | 1.2% | |
| 0.1379310345 | 1 | 0.6% | |
| 0.08108108108 | 1 | 0.6% | |
| Other values (146) | 146 | 88.5% |
| Value | Count | Frequency (%) | |
| 0.02380952381 | 1 | 0.6% | |
| 0.0243902439 | 1 | 0.6% | |
| 0.025 | 1 | 0.6% | |
| 0.02631578947 | 1 | 0.6% | |
| 0.02962962963 | 1 | 0.6% |
| Value | Count | Frequency (%) | |
| 1.245901639 | 1 | 0.6% | |
| 1.134328358 | 1 | 0.6% | |
| 1.036144578 | 1 | 0.6% | |
| 0.8875 | 1 | 0.6% | |
| 0.8513513514 | 1 | 0.6% |
cancelled
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 1.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 129 | 78.2% | |
| 1 | 36 | 21.8% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| df_index | page_count | songs_played | songs_playlisted | thumbed_up | thumbed_down | added_friends | top_location | user_gender | error_count | redirect_count | days_active | 7d_songs_played | 7d_songs_playlisted | 7d_thumbed_up | 7d_thumbed_down | 7d_added_friends | playlisted_ratio | thumbed_up_ratio | thumbed_down_ratio | songs_per_day | interactions_per_day | time_mean | session_count | inter_per_session | sessions_per_day | cancelled | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | 795 | 673.0 | 9.0 | 37.0 | 4.0 | 12.0 | 51 | 1 | 795 | 795 | 51 | 151.0 | 1.0 | 4.0 | 0.0 | 2.0 | 0.013353 | 0.054896 | 0.005935 | 12.942308 | 15.288462 | 459 | 6 | 132.500000 | 0.117647 | 0 |
| 1 | 1 | 3214 | 2682.0 | 61.0 | 148.0 | 27.0 | 49.0 | 26 | 1 | 3214 | 3214 | 64 | 284.0 | 4.0 | 20.0 | 4.0 | 4.0 | 0.022736 | 0.055162 | 0.010063 | 41.261538 | 49.446154 | 316 | 35 | 91.828571 | 0.546875 | 0 |
| 2 | 3 | 218 | 195.0 | 5.0 | 5.0 | 0.0 | 1.0 | 96 | 0 | 218 | 218 | 160 | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.025510 | 0.025510 | 0.000000 | 1.211180 | 1.354037 | 200 | 4 | 54.500000 | 0.025000 | 0 |
| 3 | 5 | 1245 | 942.0 | 23.0 | 35.0 | 11.0 | 19.0 | 104 | 0 | 1245 | 1245 | 172 | 331.0 | 7.0 | 10.0 | 4.0 | 4.0 | 0.024390 | 0.037116 | 0.011665 | 5.445087 | 7.196532 | 185 | 21 | 59.285714 | 0.122093 | 0 |
| 4 | 8 | 520 | 423.0 | 9.0 | 19.0 | 6.0 | 17.0 | 53 | 0 | 520 | 520 | 115 | 174.0 | 4.0 | 10.0 | 2.0 | 10.0 | 0.021226 | 0.044811 | 0.014151 | 3.646552 | 4.482759 | 188 | 9 | 57.777778 | 0.078261 | 1 |
| 5 | 9 | 940 | 772.0 | 30.0 | 37.0 | 6.0 | 17.0 | 56 | 0 | 940 | 940 | 68 | 128.0 | 1.0 | 4.0 | 0.0 | 5.0 | 0.038810 | 0.047865 | 0.007762 | 11.188406 | 13.623188 | 527 | 6 | 156.666667 | 0.088235 | 0 |
| 6 | 10 | 671 | 518.0 | 12.0 | 23.0 | 8.0 | 7.0 | 94 | 1 | 671 | 671 | 37 | 187.0 | 3.0 | 13.0 | 5.0 | 2.0 | 0.023121 | 0.044316 | 0.015414 | 13.631579 | 17.657895 | 211 | 10 | 67.100000 | 0.270270 | 1 |
| 7 | 13 | 600 | 476.0 | 12.0 | 18.0 | 9.0 | 2.0 | 18 | 1 | 600 | 600 | 43 | 186.0 | 6.0 | 9.0 | 5.0 | 1.0 | 0.025157 | 0.037736 | 0.018868 | 10.818182 | 13.636364 | 271 | 7 | 85.714286 | 0.162791 | 1 |
| 8 | 14 | 1392 | 1131.0 | 31.0 | 39.0 | 15.0 | 28.0 | 20 | 0 | 1392 | 1392 | 44 | 155.0 | 2.0 | 12.0 | 2.0 | 3.0 | 0.027385 | 0.034452 | 0.013251 | 25.133333 | 30.933333 | 329 | 14 | 99.428571 | 0.318182 | 1 |
| 9 | 15 | 310 | 257.0 | 7.0 | 17.0 | 3.0 | 6.0 | 72 | 1 | 310 | 310 | 85 | 60.0 | 2.0 | 5.0 | 1.0 | 1.0 | 0.027132 | 0.065891 | 0.011628 | 2.988372 | 3.604651 | 184 | 6 | 51.666667 | 0.070588 | 1 |
Last rows
| df_index | page_count | songs_played | songs_playlisted | thumbed_up | thumbed_down | added_friends | top_location | user_gender | error_count | redirect_count | days_active | 7d_songs_played | 7d_songs_playlisted | 7d_thumbed_up | 7d_thumbed_down | 7d_added_friends | playlisted_ratio | thumbed_up_ratio | thumbed_down_ratio | songs_per_day | interactions_per_day | time_mean | session_count | inter_per_session | sessions_per_day | cancelled | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 155 | 213 | 801 | 667.0 | 12.0 | 30.0 | 6.0 | 14.0 | 5 | 1 | 801 | 801 | 69 | 33.0 | 0.0 | 2.0 | 0.0 | 2.0 | 0.017964 | 0.044910 | 0.008982 | 9.528571 | 11.442857 | 550 | 5 | 160.200000 | 0.072464 | 0 |
| 156 | 214 | 3191 | 2676.0 | 77.0 | 118.0 | 32.0 | 40.0 | 12 | 1 | 3191 | 3191 | 60 | 480.0 | 11.0 | 18.0 | 3.0 | 8.0 | 0.028764 | 0.044079 | 0.011954 | 43.868852 | 52.311475 | 352 | 31 | 102.935484 | 0.516667 | 0 |
| 157 | 216 | 3014 | 2580.0 | 64.0 | 124.0 | 24.0 | 42.0 | 70 | 1 | 3014 | 3014 | 116 | 495.0 | 10.0 | 37.0 | 4.0 | 3.0 | 0.024797 | 0.048043 | 0.009299 | 22.051282 | 25.760684 | 1179 | 9 | 334.888889 | 0.077586 | 0 |
| 158 | 217 | 7230 | 5945.0 | 181.0 | 292.0 | 72.0 | 110.0 | 12 | 0 | 7230 | 7230 | 83 | 337.0 | 6.0 | 15.0 | 3.0 | 12.0 | 0.030441 | 0.049109 | 0.012109 | 70.773810 | 86.071429 | 284 | 86 | 84.069767 | 1.036145 | 0 |
| 159 | 218 | 815 | 640.0 | 17.0 | 35.0 | 4.0 | 13.0 | 3 | 1 | 815 | 815 | 71 | 350.0 | 12.0 | 19.0 | 3.0 | 8.0 | 0.026521 | 0.054602 | 0.006240 | 8.888889 | 11.319444 | 216 | 12 | 67.916667 | 0.169014 | 0 |
| 160 | 220 | 2091 | 1694.0 | 46.0 | 91.0 | 25.0 | 32.0 | 79 | 0 | 2091 | 2091 | 62 | 93.0 | 2.0 | 5.0 | 0.0 | 0.0 | 0.027139 | 0.053687 | 0.014749 | 26.888889 | 33.190476 | 211 | 33 | 63.363636 | 0.532258 | 0 |
| 161 | 221 | 2176 | 1802.0 | 52.0 | 92.0 | 24.0 | 40.0 | 6 | 0 | 2176 | 2176 | 73 | 641.0 | 14.0 | 35.0 | 7.0 | 13.0 | 0.028841 | 0.051026 | 0.013311 | 24.351351 | 29.405405 | 391 | 19 | 114.526316 | 0.260274 | 0 |
| 162 | 222 | 2404 | 1975.0 | 61.0 | 108.0 | 12.0 | 32.0 | 88 | 0 | 2404 | 2404 | 87 | 291.0 | 6.0 | 20.0 | 2.0 | 3.0 | 0.030870 | 0.054656 | 0.006073 | 22.443182 | 27.318182 | 267 | 30 | 80.133333 | 0.344828 | 0 |
| 163 | 223 | 2891 | 2401.0 | 58.0 | 115.0 | 22.0 | 45.0 | 41 | 1 | 2891 | 2891 | 63 | 234.0 | 5.0 | 6.0 | 2.0 | 5.0 | 0.024147 | 0.047877 | 0.009159 | 37.515625 | 45.171875 | 370 | 28 | 103.250000 | 0.444444 | 0 |
| 164 | 224 | 614 | 505.0 | 11.0 | 27.0 | 5.0 | 12.0 | 70 | 0 | 614 | 614 | 133 | 303.0 | 9.0 | 18.0 | 2.0 | 7.0 | 0.021739 | 0.053360 | 0.009881 | 3.768657 | 4.582090 | 190 | 11 | 55.818182 | 0.082707 | 0 |